UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UmN4t59tepthBoRwPJgxcTYFVnIqVmDO7uG9C7qoxY0='
WHERE
key_id = '54c2e6acbc725af4e87b0441bfc012467cc0975dbe98effdd55c44255eca6d07'
AND (
token = 'UmN4t59tepthBoRwPJgxcTYFVnIqVmDO7uG9C7qoxY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)