UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6tXfa6rYUzv6VHUKLz2nNzWMBroOCVd5H4MgPBXvn4I='
WHERE
key_id = 'ce79e6f2de5bc652b9240b574cb20e8bf500781d6783da0b550168b5b09c2383'
AND (
token = '6tXfa6rYUzv6VHUKLz2nNzWMBroOCVd5H4MgPBXvn4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)