UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NtxxE8HL7+ZKdw39p+XpUCu5SF+anHaV1hWdIsquszE='
WHERE
key_id = 'f6ccab675b7aa7ef2459164984f26f7fd8f1f6282783b3f67b0b0483ace677ec'
AND (
token = 'NtxxE8HL7+ZKdw39p+XpUCu5SF+anHaV1hWdIsquszE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)