UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qKtwcBFADGGhJDBo2nt51dnYxogISF1sCXNeGJlZHUU='
WHERE
key_id = '9ab0241fcb7f611451873540cc632c7fa0abd4d5460a9b11f9dcd4d9a6727589'
AND (
token = 'qKtwcBFADGGhJDBo2nt51dnYxogISF1sCXNeGJlZHUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)