UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pVLTyWYX399LPYcc3WxCVhIJuiqqjKYO4/CGOSfcqpM='
WHERE
key_id = 'dfd03dc4282395b45e09cac723129072a9ac67656215dd190732507d7b6093c9'
AND (
token = 'pVLTyWYX399LPYcc3WxCVhIJuiqqjKYO4/CGOSfcqpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)