UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7v+RKEGCDdF1yCT3rGqG5cW7NX6rr31Dhf+r/sxL/Y='
WHERE
key_id = 'cefe15e750eacae751595469c82713d00ac8336ec8ffff05fdb281d637252b4b'
AND (
token = 'a7v+RKEGCDdF1yCT3rGqG5cW7NX6rr31Dhf+r/sxL/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)