UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mXtU4XQIRQfy9vqJJrXtaiLinl8uuBcDACUcz8lFA00='
WHERE
key_id = '4e67e47ecdb5ca8fc3438a952677e13125ef69fe927443483ce7c6b7454b2192'
AND (
token = 'mXtU4XQIRQfy9vqJJrXtaiLinl8uuBcDACUcz8lFA00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)