UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YYUpSCZncFJd2yZnCDTRY8uWGhjsd9paT7ijKFUpCEY='
WHERE
key_id = '9bacc553658d675170bf9c48098957b7baa6faf7163a1cf1d265caeffd3a49bc'
AND (
token = 'YYUpSCZncFJd2yZnCDTRY8uWGhjsd9paT7ijKFUpCEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)