UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1lUOuQueYzsOA16WYEYp7r1qYvuMmrJ4NOaDZb/OPs='
WHERE
key_id = '1aa80fb14f59b4ff0a2e4535fbe53892c3968da20f592db43b801d451054e948'
AND (
token = 'z1lUOuQueYzsOA16WYEYp7r1qYvuMmrJ4NOaDZb/OPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)