UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NnDS9QTOY1s0jm6lu3rH57lZhue421fnvjxrueSp520='
WHERE
key_id = '885f17661d9f48c218465ec1c4e23310cca564f6ad759346475c9a59dd9d4458'
AND (
token = 'NnDS9QTOY1s0jm6lu3rH57lZhue421fnvjxrueSp520='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)