UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J0bqEBqN73JIN4F4dHzYmc+3a1+xEfUo3a3EhaHB8Xg='
WHERE
key_id = '81782a22e8eedc72f923fb93993ebe653f1af67c4a4f1bd65c4633679115019e'
AND (
token = 'J0bqEBqN73JIN4F4dHzYmc+3a1+xEfUo3a3EhaHB8Xg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)