UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'stRpQ8eive4brb4tG8s8l8jj4vXAaYUmqsz9RYB7eZ8='
WHERE
key_id = '45aee08d3001b3e9f1f25bad98d2eb7cfcdacb08e804ed469670dca7df01a5df'
AND (
token = 'stRpQ8eive4brb4tG8s8l8jj4vXAaYUmqsz9RYB7eZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)