UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C9hnHloUuh4ECH6exSFZiOlmDvNrA2zPva3fgX53tgE='
WHERE
key_id = '3883e05e20150337dc7cd1bf1c7a00ba9d331f652527a5c9f54d7c5f7d8c5b4d'
AND (
token = 'C9hnHloUuh4ECH6exSFZiOlmDvNrA2zPva3fgX53tgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)