UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '18ddklf9WgzBR0hFzi0eLhX8EySAexlce79rhxo4Wt8='
WHERE
key_id = '0fef4671786cf38999017ba37e5fddebc7262044cbbb4b4f16034cc4044be233'
AND (
token = '18ddklf9WgzBR0hFzi0eLhX8EySAexlce79rhxo4Wt8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)