UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gBb5ke0tCxpIJEYlWT0qXC7mHWuZQ/lOJSEMZLUoXrM='
WHERE
key_id = '8265ddf0df18ab1b2c1792bc9b1eeeb728dda9d81ccc1f1b1de84723b0867b63'
AND (
token = 'gBb5ke0tCxpIJEYlWT0qXC7mHWuZQ/lOJSEMZLUoXrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)