UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zSSBZdha/DwAJeg8B97oZa25UeX2EX5hBxloshalDjU='
WHERE
key_id = '86bb470a91d3e9ee38aefdbb78792b4ee932a726073084cf397ae489e56a29af'
AND (
token = 'zSSBZdha/DwAJeg8B97oZa25UeX2EX5hBxloshalDjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)