UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BD6mJfttRwlS1Qgcoknw0Vg8jeY4GZDWoA1MRF0GJqI='
WHERE
key_id = '7657f14e16c7c4f794a956bddc4d837034779b91f4b9e970927a4b024f480c1b'
AND (
token = 'BD6mJfttRwlS1Qgcoknw0Vg8jeY4GZDWoA1MRF0GJqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)