UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R/Ne9TOep+WHD7ou3vhrS4wujmqM8Rg13UgGPj2VI4o='
WHERE
key_id = 'c7cd0c91d5eec397effe3efb1e3bb0d2fddcd0bc7629e2038dc0a8eb03d16a9a'
AND (
token = 'R/Ne9TOep+WHD7ou3vhrS4wujmqM8Rg13UgGPj2VI4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)