UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YuIlHlRLKg35I4J9R26TtD7uV4NCp7zjJFZPfWvRP/U='
WHERE
key_id = '8d0bea7c1eb16e686519599dfbf701bacb0a0bdd85bb0b1ecd1d7cbd2e20cf28'
AND (
token = 'YuIlHlRLKg35I4J9R26TtD7uV4NCp7zjJFZPfWvRP/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)