UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ipRem0DUE9vHVIfi/nHnbjdnQFveFbSxAMmwxcRjINU='
WHERE
key_id = '231c0f898d3806896a2dca31536b0e75e29bde212f13238549054b13a634a866'
AND (
token = 'ipRem0DUE9vHVIfi/nHnbjdnQFveFbSxAMmwxcRjINU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)