UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O8RyG1U1flpMb7FXd4EVr9s7nXJzwn+OhvYnBPK5jCw='
WHERE
key_id = 'a7f4a3d12dcac2222a646abf0aa01b296983ceec159989792329835c9dcafa86'
AND (
token = 'O8RyG1U1flpMb7FXd4EVr9s7nXJzwn+OhvYnBPK5jCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)