UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xM8+GlqcVT8w9FzbKzlWZmGTAxNNWqnkgrH5cMXr0Mw='
WHERE
key_id = 'bb16112072d4cf88f66140f2b8a310449974e1501bc90bbb2dd040e90898647e'
AND (
token = 'xM8+GlqcVT8w9FzbKzlWZmGTAxNNWqnkgrH5cMXr0Mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)