UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S9LvCR/xspcEHfOFD21pASxusMokKbvbtgUvu0UF+YI='
WHERE
key_id = 'cd49f78f1d921647466da00ca4fde216f7fe0ccc28d8178c5014ad6cb28db881'
AND (
token = 'S9LvCR/xspcEHfOFD21pASxusMokKbvbtgUvu0UF+YI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)