UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7VVGeyxbOiEAKVnsDM/hQpu3sxCSXxDsy5frkwSq4gQ='
WHERE
key_id = '80e85411f5e9e16585a406a02f6e8160c2e4af63745aeda7ffe00ae25bfcf00e'
AND (
token = '7VVGeyxbOiEAKVnsDM/hQpu3sxCSXxDsy5frkwSq4gQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)