UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7hxndtNBgJTPPo0MHQvWslxHJMhrCYXElae4FrIU65o='
WHERE
key_id = 'b3e74f18d8f4e59e120e0c3ceee1bc64df9e4f742345b50e5159d966ca5f0fba'
AND (
token = '7hxndtNBgJTPPo0MHQvWslxHJMhrCYXElae4FrIU65o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)