UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcJK0IzAwH9ZaIyNQBxEhSgmQGyBFm3d1z/bfGfn4h4='
WHERE
key_id = '9effb9d79edbeed87bf5b4a7d0a91212a4153057faccdf6a8e4b498b21db510f'
AND (
token = 'XcJK0IzAwH9ZaIyNQBxEhSgmQGyBFm3d1z/bfGfn4h4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)