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