UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JX7gZ4rQJbAxzixPTpOaNCAsTBMATDHDBVPbbDDSAvw='
WHERE
key_id = 'cae315f7e48842828db39cabba24318336ccdbbd58b1a182f1fb5e4cd75b5569'
AND (
token = 'JX7gZ4rQJbAxzixPTpOaNCAsTBMATDHDBVPbbDDSAvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)