UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6HCTPantGN1vYEMzCWjZhztTv6FV8PL/bx/c6Pi6fJw='
WHERE
key_id = '978633e7fece50440571ed3ad6b93d9b6f753587c7fc41ce10ebc9aee223ae94'
AND (
token = '6HCTPantGN1vYEMzCWjZhztTv6FV8PL/bx/c6Pi6fJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)