UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FBHhN0FArpU4koJzUlQwylonGlIknNJrlr6xnbj4rA8='
WHERE
key_id = 'c4f472ed9894762e746de2c15c60b630de49be9f078d0e57c522e4b0aba3d980'
AND (
token = 'FBHhN0FArpU4koJzUlQwylonGlIknNJrlr6xnbj4rA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)