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