UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MvGYh9rPigOx7noqetC0+xy5KMdOj0vijB28e/1Ab3Q='
WHERE
key_id = 'b87827c937d8a6db5881070a4679597822527f134bc5384b155a3394bf6371b1'
AND (
token = 'MvGYh9rPigOx7noqetC0+xy5KMdOj0vijB28e/1Ab3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)