UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6u7OiGBU8IzGngqYLAlNCY359OFlFT/cpWCENydGt4o='
WHERE
key_id = '1fa65d5af85710ff3ab998d38b8e7d909abf9468eeed7234d92822318ff690a5'
AND (
token = '6u7OiGBU8IzGngqYLAlNCY359OFlFT/cpWCENydGt4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)